Data Preparation for USAspending Explorer App

New York as an exmaple

## Libraries
import requests
from bs4 import BeautifulSoup
import json
import pandas as pd
import numpy as np
from pandas.core.frame import DataFrame

import plotly.express as px
from plotly.subplots import make_subplots
import plotly.graph_objects as go

pd.set_option('display.max_rows', None)
pd.set_option('display.max_columns', None)

Scrap County Codes

• Documentation:
  • American National Standards Institute (ANSI) and Federal Information Processing Series (FIPS) Codes https://www.census.gov/library/reference/code-lists/ansi.html#county

## url for the target state 
url = "https://www2.census.gov/geo/docs/reference/codes/files/st36_ny_cou.txt"

##Request the contents of the webpage 
page = requests.get(url)
page.status_code##==200 means successful

# Parse the content 
soup = BeautifulSoup(page.text, 'lxml')
text = soup.find_all('p')
#inside of this loop you will be accessing each 'p'
for p in text:
    aa = p.text

## clean the text(remove the "\r\n")
bb = aa.split("\r\n")
##initiate an empty list 
dd = []
## loop thru each item in the list and save them in the list
for ii in bb:
    dd.append(ii.split(","))    
## transform the list into df  
data_code_0=pd.DataFrame(dd)
##filter the columns
data_code_1 = data_code_0.filter([0,1,2,3])

##rename the columns
data_code = data_code_1.rename(columns={0:"State",1:"FIPS",2:"county_code",3:"county_name"})

data_code["county_name"] = data_code["county_name"].str.replace(r'County$', '')
data_code = data_code.filter(["State","State_code","FIPS","county_code","county_name"])
data_code['county_name'] = data_code['county_name'].str.strip( )

<ipython-input-4-e84804961a16>:4: FutureWarning: The default value of regex will change from True to False in a future version.
  data_code["county_name"] = data_code["county_name"].str.replace(r'County$', '')

county_code_NY = data_code
#county_code_NY['county_name'] = county_code_NY['county_name'].apply(lambda x: x.split(' city')[0])
#county_code_NY

#county_code_NY['county_name'].str.replace(' ','')
#county_code_NY.loc[29,"county_name"] = "LaSalle Parish"
#county_code_NY

Scrap State Population Data (Wikipedia)

• Documentation:
  • List of United States counties and county equivalents https://en.wikipedia.org/wiki/List_of_United_States_counties_and_county_equivalents

wiki_url = "https://en.wikipedia.org/wiki/List_of_United_States_counties_and_county_equivalents"
table_name = 'wikitable sortable' 

response = requests.get(wiki_url)
soup = BeautifulSoup(response.text, "html.parser")

soup_table = soup.find('table', {'class':table_name})
df = pd.read_html(str(soup_table))
county_list_0 = df.pop()

#store the poplulation data
#county_list.to_csv('C:/Users/little page/Desktop/USA_spending_app/county_list_2019population.csv')

#### Read in population_abb data
population_merge_statea_bb = pd.read_csv("population_merge_statea_bb.csv")

#clean the population data
population_merge_statea_bb['County'] = population_merge_statea_bb['County'].apply(lambda x: x.split('[')[0])
population_merge_statea_bb['County'] = population_merge_statea_bb['County'].apply(lambda x: x.split(',')[0])

####extract the population_abb data of the state
county_list_2019population_NY = population_merge_statea_bb[population_merge_statea_bb["State"]=="New York"]
county_list_2019population_NY = county_list_2019population_NY.filter(["County","State","Population2019","Code"])

#county_list_2019population_NY.loc[1798,"County"] = "Dona Ana"

Merge State Population Data and State County Code

population_county_code = county_list_2019population_NY.merge(county_code_NY, how = "left", left_on='County', right_on='county_name')
population_county_code = population_county_code.filter(["State_x","State_code","Code","County","county_code","Population2019"])
#population_county_code

Request the USAspending API and Pagination

• Documentation:
  • USAspending https://www.usaspending.gov/
  • Endpoint: https://api.usaspending.gov/api/v2/search/spending_by_award

# form the urls for each county in a state based on the county code list
payload_0_list = []
for county in county_code_NY["county_code"]:
    payload_0 = {"filters": {
                  "time_period": [
                      {
                          "start_date": "2021-10-01",##FY2022
                          "end_date": "2022-09-30"
                      }],
                   "award_type_codes": [## set the category of grants
                    "02",
                    "03",
                    "04",
                    "05"
                ],
                "place_of_performance_locations": [
                    {
                        "state": "NY",
                        "county": county,
                        "country": "USA"
                    }
                ]
              },
            "fields": [
                "Award ID",
                "Recipient Name",
                "Award Amount",
                "Awarding Agency",
                "Awarding Sub Agency",
                "Place of Performance State Code"
            ],
            "page": 1,
            "limit": 100,
            "sort": "Award Amount",
            "order": "desc",
            "subawards": False}
    payload_0_list.append(payload_0)

#payload_0_list 

# request the API with url and deal with pagination 
all_county = []
for payload_0 in payload_0_list:
    response_result=[] 
    while payload_0:
        
        print("-----")
        print("Requesting",payload_0)
        url='https://api.usaspending.gov/api/v2/search/spending_by_award'
        headers={"content-type":"application/json"}
        payload = json.dumps(payload_0)
        response = requests.post(url=url, data=payload,headers=headers)

        ##grab the new list
        response_result_0=json.loads(response.text)['results']
            ##add the county code in the dic
        for ii in response_result_0:
            ii.update({"county_code": payload_0["filters"]["place_of_performance_locations"][0]['county']}) 
        response_result.extend(response_result_0)
        #all_county.extend(response_result)
        ##update the request
        response_next_page=json.loads(response.text)['page_metadata']["hasNext"]
        if response_next_page != False :
            response_page=json.loads(response.text)['page_metadata']['page'] + 1
            payload_0["page"] = response_page
        else:
            break
    all_county.extend(response_result)

-----
Requesting {'filters': {'time_period': [{'start_date': '2021-10-01', 'end_date': '2022-09-30'}], 'award_type_codes': ['02', '03', '04', '05'], 'place_of_performance_locations': [{'state': 'NY', 'county': '001', 'country': 'USA'}]}, 'fields': ['Award ID', 'Recipient Name', 'Award Amount', 'Awarding Agency', 'Awarding Sub Agency', 'Place of Performance State Code'], 'page': 1, 'limit': 100, 'sort': 'Award Amount', 'order': 'desc', 'subawards': False}
-----
Requesting {'filters': {'time_period': [{'start_date': '2021-10-01', 'end_date': '2022-09-30'}], 'award_type_codes': ['02', '03', '04', '05'], 'place_of_performance_locations': [{'state': 'NY', 'county': '001', 'country': 'USA'}]}, 'fields': ['Award ID', 'Recipient Name', 'Award Amount', 'Awarding Agency', 'Awarding Sub Agency', 'Place of Performance State Code'], 'page': 2, 'limit': 100, 'sort': 'Award Amount', 'order': 'desc', 'subawards': False}
-----
Requesting {'filters': {'time_period': [{'start_date': '2021-10-01', 'end_date': '2022-09-30'}], 'award_type_codes': ['02', '03', '04', '05'], 'place_of_performance_locations': [{'state': 'NY', 'county': '001', 'country': 'USA'}]}, 'fields': ['Award ID', 'Recipient Name', 'Award Amount', 'Awarding Agency', 'Awarding Sub Agency', 'Place of Performance State Code'], 'page': 3, 'limit': 100, 'sort': 'Award Amount', 'order': 'desc', 'subawards': False}
-----
Requesting {'filters': {'time_period': [{'start_date': '2021-10-01', 'end_date': '2022-09-30'}], 'award_type_codes': ['02', '03', '04', '05'], 'place_of_performance_locations': [{'state': 'NY', 'county': '001', 'country': 'USA'}]}, 'fields': ['Award ID', 'Recipient Name', 'Award Amount', 'Awarding Agency', 'Awarding Sub Agency', 'Place of Performance State Code'], 'page': 4, 'limit': 100, 'sort': 'Award Amount', 'order': 'desc', 'subawards': False}
-----
Requesting {'filters': {'time_period': [{'start_date': '2021-10-01', 'end_date': '2022-09-30'}], 'award_type_codes': ['02', '03', '04', '05'], 'place_of_performance_locations': [{'state': 'NY', 'county': '003', 'country': 'USA'}]}, 'fields': ['Award ID', 'Recipient Name', 'Award Amount', 'Awarding Agency', 'Awarding Sub Agency', 'Place of Performance State Code'], 'page': 1, 'limit': 100, 'sort': 'Award Amount', 'order': 'desc', 'subawards': False}
-----
Requesting {'filters': {'time_period': [{'start_date': '2021-10-01', 'end_date': '2022-09-30'}], 'award_type_codes': ['02', '03', '04', '05'], 'place_of_performance_locations': [{'state': 'NY', 'county': '005', 'country': 'USA'}]}, 'fields': ['Award ID', 'Recipient Name', 'Award Amount', 'Awarding Agency', 'Awarding Sub Agency', 'Place of Performance State Code'], 'page': 1, 'limit': 100, 'sort': 'Award Amount', 'order': 'desc', 'subawards': False}
-----
Requesting {'filters': {'time_period': [{'start_date': '2021-10-01', 'end_date': '2022-09-30'}], 'award_type_codes': ['02', '03', '04', '05'], 'place_of_performance_locations': [{'state': 'NY', 'county': '005', 'country': 'USA'}]}, 'fields': ['Award ID', 'Recipient Name', 'Award Amount', 'Awarding Agency', 'Awarding Sub Agency', 'Place of Performance State Code'], 'page': 2, 'limit': 100, 'sort': 'Award Amount', 'order': 'desc', 'subawards': False}
-----
Requesting {'filters': {'time_period': [{'start_date': '2021-10-01', 'end_date': '2022-09-30'}], 'award_type_codes': ['02', '03', '04', '05'], 'place_of_performance_locations': [{'state': 'NY', 'county': '005', 'country': 'USA'}]}, 'fields': ['Award ID', 'Recipient Name', 'Award Amount', 'Awarding Agency', 'Awarding Sub Agency', 'Place of Performance State Code'], 'page': 3, 'limit': 100, 'sort': 'Award Amount', 'order': 'desc', 'subawards': False}
-----
Requesting {'filters': {'time_period': [{'start_date': '2021-10-01', 'end_date': '2022-09-30'}], 'award_type_codes': ['02', '03', '04', '05'], 'place_of_performance_locations': [{'state': 'NY', 'county': '005', 'country': 'USA'}]}, 'fields': ['Award ID', 'Recipient Name', 'Award Amount', 'Awarding Agency', 'Awarding Sub Agency', 'Place of Performance State Code'], 'page': 4, 'limit': 100, 'sort': 'Award Amount', 'order': 'desc', 'subawards': False}
-----
Requesting {'filters': {'time_period': [{'start_date': '2021-10-01', 'end_date': '2022-09-30'}], 'award_type_codes': ['02', '03', '04', '05'], 'place_of_performance_locations': [{'state': 'NY', 'county': '007', 'country': 'USA'}]}, 'fields': ['Award ID', 'Recipient Name', 'Award Amount', 'Awarding Agency', 'Awarding Sub Agency', 'Place of Performance State Code'], 'page': 1, 'limit': 100, 'sort': 'Award Amount', 'order': 'desc', 'subawards': False}
-----
Requesting {'filters': {'time_period': [{'start_date': '2021-10-01', 'end_date': '2022-09-30'}], 'award_type_codes': ['02', '03', '04', '05'], 'place_of_performance_locations': [{'state': 'NY', 'county': '009', 'country': 'USA'}]}, 'fields': ['Award ID', 'Recipient Name', 'Award Amount', 'Awarding Agency', 'Awarding Sub Agency', 'Place of Performance State Code'], 'page': 1, 'limit': 100, 'sort': 'Award Amount', 'order': 'desc', 'subawards': False}
-----
Requesting {'filters': {'time_period': [{'start_date': '2021-10-01', 'end_date': '2022-09-30'}], 'award_type_codes': ['02', '03', '04', '05'], 'place_of_performance_locations': [{'state': 'NY', 'county': '011', 'country': 'USA'}]}, 'fields': ['Award ID', 'Recipient Name', 'Award Amount', 'Awarding Agency', 'Awarding Sub Agency', 'Place of Performance State Code'], 'page': 1, 'limit': 100, 'sort': 'Award Amount', 'order': 'desc', 'subawards': False}
-----
Requesting {'filters': {'time_period': [{'start_date': '2021-10-01', 'end_date': '2022-09-30'}], 'award_type_codes': ['02', '03', '04', '05'], 'place_of_performance_locations': [{'state': 'NY', 'county': '013', 'country': 'USA'}]}, 'fields': ['Award ID', 'Recipient Name', 'Award Amount', 'Awarding Agency', 'Awarding Sub Agency', 'Place of Performance State Code'], 'page': 1, 'limit': 100, 'sort': 'Award Amount', 'order': 'desc', 'subawards': False}
-----
Requesting {'filters': {'time_period': [{'start_date': '2021-10-01', 'end_date': '2022-09-30'}], 'award_type_codes': ['02', '03', '04', '05'], 'place_of_performance_locations': [{'state': 'NY', 'county': '015', 'country': 'USA'}]}, 'fields': ['Award ID', 'Recipient Name', 'Award Amount', 'Awarding Agency', 'Awarding Sub Agency', 'Place of Performance State Code'], 'page': 1, 'limit': 100, 'sort': 'Award Amount', 'order': 'desc', 'subawards': False}
-----
Requesting {'filters': {'time_period': [{'start_date': '2021-10-01', 'end_date': '2022-09-30'}], 'award_type_codes': ['02', '03', '04', '05'], 'place_of_performance_locations': [{'state': 'NY', 'county': '017', 'country': 'USA'}]}, 'fields': ['Award ID', 'Recipient Name', 'Award Amount', 'Awarding Agency', 'Awarding Sub Agency', 'Place of Performance State Code'], 'page': 1, 'limit': 100, 'sort': 'Award Amount', 'order': 'desc', 'subawards': False}
-----
Requesting {'filters': {'time_period': [{'start_date': '2021-10-01', 'end_date': '2022-09-30'}], 'award_type_codes': ['02', '03', '04', '05'], 'place_of_performance_locations': [{'state': 'NY', 'county': '019', 'country': 'USA'}]}, 'fields': ['Award ID', 'Recipient Name', 'Award Amount', 'Awarding Agency', 'Awarding Sub Agency', 'Place of Performance State Code'], 'page': 1, 'limit': 100, 'sort': 'Award Amount', 'order': 'desc', 'subawards': False}
-----
Requesting {'filters': {'time_period': [{'start_date': '2021-10-01', 'end_date': '2022-09-30'}], 'award_type_codes': ['02', '03', '04', '05'], 'place_of_performance_locations': [{'state': 'NY', 'county': '021', 'country': 'USA'}]}, 'fields': ['Award ID', 'Recipient Name', 'Award Amount', 'Awarding Agency', 'Awarding Sub Agency', 'Place of Performance State Code'], 'page': 1, 'limit': 100, 'sort': 'Award Amount', 'order': 'desc', 'subawards': False}
-----
Requesting {'filters': {'time_period': [{'start_date': '2021-10-01', 'end_date': '2022-09-30'}], 'award_type_codes': ['02', '03', '04', '05'], 'place_of_performance_locations': [{'state': 'NY', 'county': '023', 'country': 'USA'}]}, 'fields': ['Award ID', 'Recipient Name', 'Award Amount', 'Awarding Agency', 'Awarding Sub Agency', 'Place of Performance State Code'], 'page': 1, 'limit': 100, 'sort': 'Award Amount', 'order': 'desc', 'subawards': False}
-----
Requesting {'filters': {'time_period': [{'start_date': '2021-10-01', 'end_date': '2022-09-30'}], 'award_type_codes': ['02', '03', '04', '05'], 'place_of_performance_locations': [{'state': 'NY', 'county': '025', 'country': 'USA'}]}, 'fields': ['Award ID', 'Recipient Name', 'Award Amount', 'Awarding Agency', 'Awarding Sub Agency', 'Place of Performance State Code'], 'page': 1, 'limit': 100, 'sort': 'Award Amount', 'order': 'desc', 'subawards': False}
-----
Requesting {'filters': {'time_period': [{'start_date': '2021-10-01', 'end_date': '2022-09-30'}], 'award_type_codes': ['02', '03', '04', '05'], 'place_of_performance_locations': [{'state': 'NY', 'county': '027', 'country': 'USA'}]}, 'fields': ['Award ID', 'Recipient Name', 'Award Amount', 'Awarding Agency', 'Awarding Sub Agency', 'Place of Performance State Code'], 'page': 1, 'limit': 100, 'sort': 'Award Amount', 'order': 'desc', 'subawards': False}
-----
Requesting {'filters': {'time_period': [{'start_date': '2021-10-01', 'end_date': '2022-09-30'}], 'award_type_codes': ['02', '03', '04', '05'], 'place_of_performance_locations': [{'state': 'NY', 'county': '029', 'country': 'USA'}]}, 'fields': ['Award ID', 'Recipient Name', 'Award Amount', 'Awarding Agency', 'Awarding Sub Agency', 'Place of Performance State Code'], 'page': 1, 'limit': 100, 'sort': 'Award Amount', 'order': 'desc', 'subawards': False}
-----
Requesting {'filters': {'time_period': [{'start_date': '2021-10-01', 'end_date': '2022-09-30'}], 'award_type_codes': ['02', '03', '04', '05'], 'place_of_performance_locations': [{'state': 'NY', 'county': '029', 'country': 'USA'}]}, 'fields': ['Award ID', 'Recipient Name', 'Award Amount', 'Awarding Agency', 'Awarding Sub Agency', 'Place of Performance State Code'], 'page': 2, 'limit': 100, 'sort': 'Award Amount', 'order': 'desc', 'subawards': False}
-----
Requesting {'filters': {'time_period': [{'start_date': '2021-10-01', 'end_date': '2022-09-30'}], 'award_type_codes': ['02', '03', '04', '05'], 'place_of_performance_locations': [{'state': 'NY', 'county': '029', 'country': 'USA'}]}, 'fields': ['Award ID', 'Recipient Name', 'Award Amount', 'Awarding Agency', 'Awarding Sub Agency', 'Place of Performance State Code'], 'page': 3, 'limit': 100, 'sort': 'Award Amount', 'order': 'desc', 'subawards': False}
-----
Requesting {'filters': {'time_period': [{'start_date': '2021-10-01', 'end_date': '2022-09-30'}], 'award_type_codes': ['02', '03', '04', '05'], 'place_of_performance_locations': [{'state': 'NY', 'county': '029', 'country': 'USA'}]}, 'fields': ['Award ID', 'Recipient Name', 'Award Amount', 'Awarding Agency', 'Awarding Sub Agency', 'Place of Performance State Code'], 'page': 4, 'limit': 100, 'sort': 'Award Amount', 'order': 'desc', 'subawards': False}
-----
Requesting {'filters': {'time_period': [{'start_date': '2021-10-01', 'end_date': '2022-09-30'}], 'award_type_codes': ['02', '03', '04', '05'], 'place_of_performance_locations': [{'state': 'NY', 'county': '029', 'country': 'USA'}]}, 'fields': ['Award ID', 'Recipient Name', 'Award Amount', 'Awarding Agency', 'Awarding Sub Agency', 'Place of Performance State Code'], 'page': 5, 'limit': 100, 'sort': 'Award Amount', 'order': 'desc', 'subawards': False}
-----
Requesting {'filters': {'time_period': [{'start_date': '2021-10-01', 'end_date': '2022-09-30'}], 'award_type_codes': ['02', '03', '04', '05'], 'place_of_performance_locations': [{'state': 'NY', 'county': '031', 'country': 'USA'}]}, 'fields': ['Award ID', 'Recipient Name', 'Award Amount', 'Awarding Agency', 'Awarding Sub Agency', 'Place of Performance State Code'], 'page': 1, 'limit': 100, 'sort': 'Award Amount', 'order': 'desc', 'subawards': False}
-----
Requesting {'filters': {'time_period': [{'start_date': '2021-10-01', 'end_date': '2022-09-30'}], 'award_type_codes': ['02', '03', '04', '05'], 'place_of_performance_locations': [{'state': 'NY', 'county': '033', 'country': 'USA'}]}, 'fields': ['Award ID', 'Recipient Name', 'Award Amount', 'Awarding Agency', 'Awarding Sub Agency', 'Place of Performance State Code'], 'page': 1, 'limit': 100, 'sort': 'Award Amount', 'order': 'desc', 'subawards': False}
-----
Requesting {'filters': {'time_period': [{'start_date': '2021-10-01', 'end_date': '2022-09-30'}], 'award_type_codes': ['02', '03', '04', '05'], 'place_of_performance_locations': [{'state': 'NY', 'county': '035', 'country': 'USA'}]}, 'fields': ['Award ID', 'Recipient Name', 'Award Amount', 'Awarding Agency', 'Awarding Sub Agency', 'Place of Performance State Code'], 'page': 1, 'limit': 100, 'sort': 'Award Amount', 'order': 'desc', 'subawards': False}
-----
Requesting {'filters': {'time_period': [{'start_date': '2021-10-01', 'end_date': '2022-09-30'}], 'award_type_codes': ['02', '03', '04', '05'], 'place_of_performance_locations': [{'state': 'NY', 'county': '037', 'country': 'USA'}]}, 'fields': ['Award ID', 'Recipient Name', 'Award Amount', 'Awarding Agency', 'Awarding Sub Agency', 'Place of Performance State Code'], 'page': 1, 'limit': 100, 'sort': 'Award Amount', 'order': 'desc', 'subawards': False}
-----
Requesting {'filters': {'time_period': [{'start_date': '2021-10-01', 'end_date': '2022-09-30'}], 'award_type_codes': ['02', '03', '04', '05'], 'place_of_performance_locations': [{'state': 'NY', 'county': '039', 'country': 'USA'}]}, 'fields': ['Award ID', 'Recipient Name', 'Award Amount', 'Awarding Agency', 'Awarding Sub Agency', 'Place of Performance State Code'], 'page': 1, 'limit': 100, 'sort': 'Award Amount', 'order': 'desc', 'subawards': False}
-----
Requesting {'filters': {'time_period': [{'start_date': '2021-10-01', 'end_date': '2022-09-30'}], 'award_type_codes': ['02', '03', '04', '05'], 'place_of_performance_locations': [{'state': 'NY', 'county': '041', 'country': 'USA'}]}, 'fields': ['Award ID', 'Recipient Name', 'Award Amount', 'Awarding Agency', 'Awarding Sub Agency', 'Place of Performance State Code'], 'page': 1, 'limit': 100, 'sort': 'Award Amount', 'order': 'desc', 'subawards': False}
-----
Requesting {'filters': {'time_period': [{'start_date': '2021-10-01', 'end_date': '2022-09-30'}], 'award_type_codes': ['02', '03', '04', '05'], 'place_of_performance_locations': [{'state': 'NY', 'county': '043', 'country': 'USA'}]}, 'fields': ['Award ID', 'Recipient Name', 'Award Amount', 'Awarding Agency', 'Awarding Sub Agency', 'Place of Performance State Code'], 'page': 1, 'limit': 100, 'sort': 'Award Amount', 'order': 'desc', 'subawards': False}
-----
Requesting {'filters': {'time_period': [{'start_date': '2021-10-01', 'end_date': '2022-09-30'}], 'award_type_codes': ['02', '03', '04', '05'], 'place_of_performance_locations': [{'state': 'NY', 'county': '045', 'country': 'USA'}]}, 'fields': ['Award ID', 'Recipient Name', 'Award Amount', 'Awarding Agency', 'Awarding Sub Agency', 'Place of Performance State Code'], 'page': 1, 'limit': 100, 'sort': 'Award Amount', 'order': 'desc', 'subawards': False}
-----
Requesting {'filters': {'time_period': [{'start_date': '2021-10-01', 'end_date': '2022-09-30'}], 'award_type_codes': ['02', '03', '04', '05'], 'place_of_performance_locations': [{'state': 'NY', 'county': '047', 'country': 'USA'}]}, 'fields': ['Award ID', 'Recipient Name', 'Award Amount', 'Awarding Agency', 'Awarding Sub Agency', 'Place of Performance State Code'], 'page': 1, 'limit': 100, 'sort': 'Award Amount', 'order': 'desc', 'subawards': False}
-----
Requesting {'filters': {'time_period': [{'start_date': '2021-10-01', 'end_date': '2022-09-30'}], 'award_type_codes': ['02', '03', '04', '05'], 'place_of_performance_locations': [{'state': 'NY', 'county': '047', 'country': 'USA'}]}, 'fields': ['Award ID', 'Recipient Name', 'Award Amount', 'Awarding Agency', 'Awarding Sub Agency', 'Place of Performance State Code'], 'page': 2, 'limit': 100, 'sort': 'Award Amount', 'order': 'desc', 'subawards': False}
-----
Requesting {'filters': {'time_period': [{'start_date': '2021-10-01', 'end_date': '2022-09-30'}], 'award_type_codes': ['02', '03', '04', '05'], 'place_of_performance_locations': [{'state': 'NY', 'county': '047', 'country': 'USA'}]}, 'fields': ['Award ID', 'Recipient Name', 'Award Amount', 'Awarding Agency', 'Awarding Sub Agency', 'Place of Performance State Code'], 'page': 3, 'limit': 100, 'sort': 'Award Amount', 'order': 'desc', 'subawards': False}
-----
Requesting {'filters': {'time_period': [{'start_date': '2021-10-01', 'end_date': '2022-09-30'}], 'award_type_codes': ['02', '03', '04', '05'], 'place_of_performance_locations': [{'state': 'NY', 'county': '049', 'country': 'USA'}]}, 'fields': ['Award ID', 'Recipient Name', 'Award Amount', 'Awarding Agency', 'Awarding Sub Agency', 'Place of Performance State Code'], 'page': 1, 'limit': 100, 'sort': 'Award Amount', 'order': 'desc', 'subawards': False}
-----
Requesting {'filters': {'time_period': [{'start_date': '2021-10-01', 'end_date': '2022-09-30'}], 'award_type_codes': ['02', '03', '04', '05'], 'place_of_performance_locations': [{'state': 'NY', 'county': '051', 'country': 'USA'}]}, 'fields': ['Award ID', 'Recipient Name', 'Award Amount', 'Awarding Agency', 'Awarding Sub Agency', 'Place of Performance State Code'], 'page': 1, 'limit': 100, 'sort': 'Award Amount', 'order': 'desc', 'subawards': False}
-----
Requesting {'filters': {'time_period': [{'start_date': '2021-10-01', 'end_date': '2022-09-30'}], 'award_type_codes': ['02', '03', '04', '05'], 'place_of_performance_locations': [{'state': 'NY', 'county': '053', 'country': 'USA'}]}, 'fields': ['Award ID', 'Recipient Name', 'Award Amount', 'Awarding Agency', 'Awarding Sub Agency', 'Place of Performance State Code'], 'page': 1, 'limit': 100, 'sort': 'Award Amount', 'order': 'desc', 'subawards': False}
-----
Requesting {'filters': {'time_period': [{'start_date': '2021-10-01', 'end_date': '2022-09-30'}], 'award_type_codes': ['02', '03', '04', '05'], 'place_of_performance_locations': [{'state': 'NY', 'county': '055', 'country': 'USA'}]}, 'fields': ['Award ID', 'Recipient Name', 'Award Amount', 'Awarding Agency', 'Awarding Sub Agency', 'Place of Performance State Code'], 'page': 1, 'limit': 100, 'sort': 'Award Amount', 'order': 'desc', 'subawards': False}
-----
Requesting {'filters': {'time_period': [{'start_date': '2021-10-01', 'end_date': '2022-09-30'}], 'award_type_codes': ['02', '03', '04', '05'], 'place_of_performance_locations': [{'state': 'NY', 'county': '055', 'country': 'USA'}]}, 'fields': ['Award ID', 'Recipient Name', 'Award Amount', 'Awarding Agency', 'Awarding Sub Agency', 'Place of Performance State Code'], 'page': 2, 'limit': 100, 'sort': 'Award Amount', 'order': 'desc', 'subawards': False}
-----
Requesting {'filters': {'time_period': [{'start_date': '2021-10-01', 'end_date': '2022-09-30'}], 'award_type_codes': ['02', '03', '04', '05'], 'place_of_performance_locations': [{'state': 'NY', 'county': '055', 'country': 'USA'}]}, 'fields': ['Award ID', 'Recipient Name', 'Award Amount', 'Awarding Agency', 'Awarding Sub Agency', 'Place of Performance State Code'], 'page': 3, 'limit': 100, 'sort': 'Award Amount', 'order': 'desc', 'subawards': False}
-----
Requesting {'filters': {'time_period': [{'start_date': '2021-10-01', 'end_date': '2022-09-30'}], 'award_type_codes': ['02', '03', '04', '05'], 'place_of_performance_locations': [{'state': 'NY', 'county': '055', 'country': 'USA'}]}, 'fields': ['Award ID', 'Recipient Name', 'Award Amount', 'Awarding Agency', 'Awarding Sub Agency', 'Place of Performance State Code'], 'page': 4, 'limit': 100, 'sort': 'Award Amount', 'order': 'desc', 'subawards': False}
-----
Requesting {'filters': {'time_period': [{'start_date': '2021-10-01', 'end_date': '2022-09-30'}], 'award_type_codes': ['02', '03', '04', '05'], 'place_of_performance_locations': [{'state': 'NY', 'county': '055', 'country': 'USA'}]}, 'fields': ['Award ID', 'Recipient Name', 'Award Amount', 'Awarding Agency', 'Awarding Sub Agency', 'Place of Performance State Code'], 'page': 5, 'limit': 100, 'sort': 'Award Amount', 'order': 'desc', 'subawards': False}
-----
Requesting {'filters': {'time_period': [{'start_date': '2021-10-01', 'end_date': '2022-09-30'}], 'award_type_codes': ['02', '03', '04', '05'], 'place_of_performance_locations': [{'state': 'NY', 'county': '057', 'country': 'USA'}]}, 'fields': ['Award ID', 'Recipient Name', 'Award Amount', 'Awarding Agency', 'Awarding Sub Agency', 'Place of Performance State Code'], 'page': 1, 'limit': 100, 'sort': 'Award Amount', 'order': 'desc', 'subawards': False}
-----
Requesting {'filters': {'time_period': [{'start_date': '2021-10-01', 'end_date': '2022-09-30'}], 'award_type_codes': ['02', '03', '04', '05'], 'place_of_performance_locations': [{'state': 'NY', 'county': '059', 'country': 'USA'}]}, 'fields': ['Award ID', 'Recipient Name', 'Award Amount', 'Awarding Agency', 'Awarding Sub Agency', 'Place of Performance State Code'], 'page': 1, 'limit': 100, 'sort': 'Award Amount', 'order': 'desc', 'subawards': False}
-----
Requesting {'filters': {'time_period': [{'start_date': '2021-10-01', 'end_date': '2022-09-30'}], 'award_type_codes': ['02', '03', '04', '05'], 'place_of_performance_locations': [{'state': 'NY', 'county': '059', 'country': 'USA'}]}, 'fields': ['Award ID', 'Recipient Name', 'Award Amount', 'Awarding Agency', 'Awarding Sub Agency', 'Place of Performance State Code'], 'page': 2, 'limit': 100, 'sort': 'Award Amount', 'order': 'desc', 'subawards': False}
-----
Requesting {'filters': {'time_period': [{'start_date': '2021-10-01', 'end_date': '2022-09-30'}], 'award_type_codes': ['02', '03', '04', '05'], 'place_of_performance_locations': [{'state': 'NY', 'county': '061', 'country': 'USA'}]}, 'fields': ['Award ID', 'Recipient Name', 'Award Amount', 'Awarding Agency', 'Awarding Sub Agency', 'Place of Performance State Code'], 'page': 1, 'limit': 100, 'sort': 'Award Amount', 'order': 'desc', 'subawards': False}
-----
Requesting {'filters': {'time_period': [{'start_date': '2021-10-01', 'end_date': '2022-09-30'}], 'award_type_codes': ['02', '03', '04', '05'], 'place_of_performance_locations': [{'state': 'NY', 'county': '061', 'country': 'USA'}]}, 'fields': ['Award ID', 'Recipient Name', 'Award Amount', 'Awarding Agency', 'Awarding Sub Agency', 'Place of Performance State Code'], 'page': 2, 'limit': 100, 'sort': 'Award Amount', 'order': 'desc', 'subawards': False}
-----
Requesting {'filters': {'time_period': [{'start_date': '2021-10-01', 'end_date': '2022-09-30'}], 'award_type_codes': ['02', '03', '04', '05'], 'place_of_performance_locations': [{'state': 'NY', 'county': '061', 'country': 'USA'}]}, 'fields': ['Award ID', 'Recipient Name', 'Award Amount', 'Awarding Agency', 'Awarding Sub Agency', 'Place of Performance State Code'], 'page': 3, 'limit': 100, 'sort': 'Award Amount', 'order': 'desc', 'subawards': False}
-----
Requesting {'filters': {'time_period': [{'start_date': '2021-10-01', 'end_date': '2022-09-30'}], 'award_type_codes': ['02', '03', '04', '05'], 'place_of_performance_locations': [{'state': 'NY', 'county': '061', 'country': 'USA'}]}, 'fields': ['Award ID', 'Recipient Name', 'Award Amount', 'Awarding Agency', 'Awarding Sub Agency', 'Place of Performance State Code'], 'page': 4, 'limit': 100, 'sort': 'Award Amount', 'order': 'desc', 'subawards': False}
-----
Requesting {'filters': {'time_period': [{'start_date': '2021-10-01', 'end_date': '2022-09-30'}], 'award_type_codes': ['02', '03', '04', '05'], 'place_of_performance_locations': [{'state': 'NY', 'county': '061', 'country': 'USA'}]}, 'fields': ['Award ID', 'Recipient Name', 'Award Amount', 'Awarding Agency', 'Awarding Sub Agency', 'Place of Performance State Code'], 'page': 5, 'limit': 100, 'sort': 'Award Amount', 'order': 'desc', 'subawards': False}
-----
Requesting {'filters': {'time_period': [{'start_date': '2021-10-01', 'end_date': '2022-09-30'}], 'award_type_codes': ['02', '03', '04', '05'], 'place_of_performance_locations': [{'state': 'NY', 'county': '061', 'country': 'USA'}]}, 'fields': ['Award ID', 'Recipient Name', 'Award Amount', 'Awarding Agency', 'Awarding Sub Agency', 'Place of Performance State Code'], 'page': 6, 'limit': 100, 'sort': 'Award Amount', 'order': 'desc', 'subawards': False}
-----
Requesting {'filters': {'time_period': [{'start_date': '2021-10-01', 'end_date': '2022-09-30'}], 'award_type_codes': ['02', '03', '04', '05'], 'place_of_performance_locations': [{'state': 'NY', 'county': '061', 'country': 'USA'}]}, 'fields': ['Award ID', 'Recipient Name', 'Award Amount', 'Awarding Agency', 'Awarding Sub Agency', 'Place of Performance State Code'], 'page': 7, 'limit': 100, 'sort': 'Award Amount', 'order': 'desc', 'subawards': False}
-----
Requesting {'filters': {'time_period': [{'start_date': '2021-10-01', 'end_date': '2022-09-30'}], 'award_type_codes': ['02', '03', '04', '05'], 'place_of_performance_locations': [{'state': 'NY', 'county': '061', 'country': 'USA'}]}, 'fields': ['Award ID', 'Recipient Name', 'Award Amount', 'Awarding Agency', 'Awarding Sub Agency', 'Place of Performance State Code'], 'page': 8, 'limit': 100, 'sort': 'Award Amount', 'order': 'desc', 'subawards': False}
-----
Requesting {'filters': {'time_period': [{'start_date': '2021-10-01', 'end_date': '2022-09-30'}], 'award_type_codes': ['02', '03', '04', '05'], 'place_of_performance_locations': [{'state': 'NY', 'county': '061', 'country': 'USA'}]}, 'fields': ['Award ID', 'Recipient Name', 'Award Amount', 'Awarding Agency', 'Awarding Sub Agency', 'Place of Performance State Code'], 'page': 9, 'limit': 100, 'sort': 'Award Amount', 'order': 'desc', 'subawards': False}
-----
Requesting {'filters': {'time_period': [{'start_date': '2021-10-01', 'end_date': '2022-09-30'}], 'award_type_codes': ['02', '03', '04', '05'], 'place_of_performance_locations': [{'state': 'NY', 'county': '061', 'country': 'USA'}]}, 'fields': ['Award ID', 'Recipient Name', 'Award Amount', 'Awarding Agency', 'Awarding Sub Agency', 'Place of Performance State Code'], 'page': 10, 'limit': 100, 'sort': 'Award Amount', 'order': 'desc', 'subawards': False}
-----
Requesting {'filters': {'time_period': [{'start_date': '2021-10-01', 'end_date': '2022-09-30'}], 'award_type_codes': ['02', '03', '04', '05'], 'place_of_performance_locations': [{'state': 'NY', 'county': '061', 'country': 'USA'}]}, 'fields': ['Award ID', 'Recipient Name', 'Award Amount', 'Awarding Agency', 'Awarding Sub Agency', 'Place of Performance State Code'], 'page': 11, 'limit': 100, 'sort': 'Award Amount', 'order': 'desc', 'subawards': False}
-----
Requesting {'filters': {'time_period': [{'start_date': '2021-10-01', 'end_date': '2022-09-30'}], 'award_type_codes': ['02', '03', '04', '05'], 'place_of_performance_locations': [{'state': 'NY', 'county': '061', 'country': 'USA'}]}, 'fields': ['Award ID', 'Recipient Name', 'Award Amount', 'Awarding Agency', 'Awarding Sub Agency', 'Place of Performance State Code'], 'page': 12, 'limit': 100, 'sort': 'Award Amount', 'order': 'desc', 'subawards': False}
-----
Requesting {'filters': {'time_period': [{'start_date': '2021-10-01', 'end_date': '2022-09-30'}], 'award_type_codes': ['02', '03', '04', '05'], 'place_of_performance_locations': [{'state': 'NY', 'county': '061', 'country': 'USA'}]}, 'fields': ['Award ID', 'Recipient Name', 'Award Amount', 'Awarding Agency', 'Awarding Sub Agency', 'Place of Performance State Code'], 'page': 13, 'limit': 100, 'sort': 'Award Amount', 'order': 'desc', 'subawards': False}
-----
Requesting {'filters': {'time_period': [{'start_date': '2021-10-01', 'end_date': '2022-09-30'}], 'award_type_codes': ['02', '03', '04', '05'], 'place_of_performance_locations': [{'state': 'NY', 'county': '061', 'country': 'USA'}]}, 'fields': ['Award ID', 'Recipient Name', 'Award Amount', 'Awarding Agency', 'Awarding Sub Agency', 'Place of Performance State Code'], 'page': 14, 'limit': 100, 'sort': 'Award Amount', 'order': 'desc', 'subawards': False}
-----
Requesting {'filters': {'time_period': [{'start_date': '2021-10-01', 'end_date': '2022-09-30'}], 'award_type_codes': ['02', '03', '04', '05'], 'place_of_performance_locations': [{'state': 'NY', 'county': '061', 'country': 'USA'}]}, 'fields': ['Award ID', 'Recipient Name', 'Award Amount', 'Awarding Agency', 'Awarding Sub Agency', 'Place of Performance State Code'], 'page': 15, 'limit': 100, 'sort': 'Award Amount', 'order': 'desc', 'subawards': False}
-----
Requesting {'filters': {'time_period': [{'start_date': '2021-10-01', 'end_date': '2022-09-30'}], 'award_type_codes': ['02', '03', '04', '05'], 'place_of_performance_locations': [{'state': 'NY', 'county': '061', 'country': 'USA'}]}, 'fields': ['Award ID', 'Recipient Name', 'Award Amount', 'Awarding Agency', 'Awarding Sub Agency', 'Place of Performance State Code'], 'page': 16, 'limit': 100, 'sort': 'Award Amount', 'order': 'desc', 'subawards': False}
-----
Requesting {'filters': {'time_period': [{'start_date': '2021-10-01', 'end_date': '2022-09-30'}], 'award_type_codes': ['02', '03', '04', '05'], 'place_of_performance_locations': [{'state': 'NY', 'county': '061', 'country': 'USA'}]}, 'fields': ['Award ID', 'Recipient Name', 'Award Amount', 'Awarding Agency', 'Awarding Sub Agency', 'Place of Performance State Code'], 'page': 17, 'limit': 100, 'sort': 'Award Amount', 'order': 'desc', 'subawards': False}
-----
Requesting {'filters': {'time_period': [{'start_date': '2021-10-01', 'end_date': '2022-09-30'}], 'award_type_codes': ['02', '03', '04', '05'], 'place_of_performance_locations': [{'state': 'NY', 'county': '061', 'country': 'USA'}]}, 'fields': ['Award ID', 'Recipient Name', 'Award Amount', 'Awarding Agency', 'Awarding Sub Agency', 'Place of Performance State Code'], 'page': 18, 'limit': 100, 'sort': 'Award Amount', 'order': 'desc', 'subawards': False}
-----
Requesting {'filters': {'time_period': [{'start_date': '2021-10-01', 'end_date': '2022-09-30'}], 'award_type_codes': ['02', '03', '04', '05'], 'place_of_performance_locations': [{'state': 'NY', 'county': '061', 'country': 'USA'}]}, 'fields': ['Award ID', 'Recipient Name', 'Award Amount', 'Awarding Agency', 'Awarding Sub Agency', 'Place of Performance State Code'], 'page': 19, 'limit': 100, 'sort': 'Award Amount', 'order': 'desc', 'subawards': False}
-----
Requesting {'filters': {'time_period': [{'start_date': '2021-10-01', 'end_date': '2022-09-30'}], 'award_type_codes': ['02', '03', '04', '05'], 'place_of_performance_locations': [{'state': 'NY', 'county': '061', 'country': 'USA'}]}, 'fields': ['Award ID', 'Recipient Name', 'Award Amount', 'Awarding Agency', 'Awarding Sub Agency', 'Place of Performance State Code'], 'page': 20, 'limit': 100, 'sort': 'Award Amount', 'order': 'desc', 'subawards': False}
-----
Requesting {'filters': {'time_period': [{'start_date': '2021-10-01', 'end_date': '2022-09-30'}], 'award_type_codes': ['02', '03', '04', '05'], 'place_of_performance_locations': [{'state': 'NY', 'county': '061', 'country': 'USA'}]}, 'fields': ['Award ID', 'Recipient Name', 'Award Amount', 'Awarding Agency', 'Awarding Sub Agency', 'Place of Performance State Code'], 'page': 21, 'limit': 100, 'sort': 'Award Amount', 'order': 'desc', 'subawards': False}
-----
Requesting {'filters': {'time_period': [{'start_date': '2021-10-01', 'end_date': '2022-09-30'}], 'award_type_codes': ['02', '03', '04', '05'], 'place_of_performance_locations': [{'state': 'NY', 'county': '061', 'country': 'USA'}]}, 'fields': ['Award ID', 'Recipient Name', 'Award Amount', 'Awarding Agency', 'Awarding Sub Agency', 'Place of Performance State Code'], 'page': 22, 'limit': 100, 'sort': 'Award Amount', 'order': 'desc', 'subawards': False}
-----
Requesting {'filters': {'time_period': [{'start_date': '2021-10-01', 'end_date': '2022-09-30'}], 'award_type_codes': ['02', '03', '04', '05'], 'place_of_performance_locations': [{'state': 'NY', 'county': '061', 'country': 'USA'}]}, 'fields': ['Award ID', 'Recipient Name', 'Award Amount', 'Awarding Agency', 'Awarding Sub Agency', 'Place of Performance State Code'], 'page': 23, 'limit': 100, 'sort': 'Award Amount', 'order': 'desc', 'subawards': False}
-----
Requesting {'filters': {'time_period': [{'start_date': '2021-10-01', 'end_date': '2022-09-30'}], 'award_type_codes': ['02', '03', '04', '05'], 'place_of_performance_locations': [{'state': 'NY', 'county': '061', 'country': 'USA'}]}, 'fields': ['Award ID', 'Recipient Name', 'Award Amount', 'Awarding Agency', 'Awarding Sub Agency', 'Place of Performance State Code'], 'page': 24, 'limit': 100, 'sort': 'Award Amount', 'order': 'desc', 'subawards': False}
-----
Requesting {'filters': {'time_period': [{'start_date': '2021-10-01', 'end_date': '2022-09-30'}], 'award_type_codes': ['02', '03', '04', '05'], 'place_of_performance_locations': [{'state': 'NY', 'county': '061', 'country': 'USA'}]}, 'fields': ['Award ID', 'Recipient Name', 'Award Amount', 'Awarding Agency', 'Awarding Sub Agency', 'Place of Performance State Code'], 'page': 25, 'limit': 100, 'sort': 'Award Amount', 'order': 'desc', 'subawards': False}
-----
Requesting {'filters': {'time_period': [{'start_date': '2021-10-01', 'end_date': '2022-09-30'}], 'award_type_codes': ['02', '03', '04', '05'], 'place_of_performance_locations': [{'state': 'NY', 'county': '061', 'country': 'USA'}]}, 'fields': ['Award ID', 'Recipient Name', 'Award Amount', 'Awarding Agency', 'Awarding Sub Agency', 'Place of Performance State Code'], 'page': 26, 'limit': 100, 'sort': 'Award Amount', 'order': 'desc', 'subawards': False}
-----
Requesting {'filters': {'time_period': [{'start_date': '2021-10-01', 'end_date': '2022-09-30'}], 'award_type_codes': ['02', '03', '04', '05'], 'place_of_performance_locations': [{'state': 'NY', 'county': '061', 'country': 'USA'}]}, 'fields': ['Award ID', 'Recipient Name', 'Award Amount', 'Awarding Agency', 'Awarding Sub Agency', 'Place of Performance State Code'], 'page': 27, 'limit': 100, 'sort': 'Award Amount', 'order': 'desc', 'subawards': False}
-----
Requesting {'filters': {'time_period': [{'start_date': '2021-10-01', 'end_date': '2022-09-30'}], 'award_type_codes': ['02', '03', '04', '05'], 'place_of_performance_locations': [{'state': 'NY', 'county': '061', 'country': 'USA'}]}, 'fields': ['Award ID', 'Recipient Name', 'Award Amount', 'Awarding Agency', 'Awarding Sub Agency', 'Place of Performance State Code'], 'page': 28, 'limit': 100, 'sort': 'Award Amount', 'order': 'desc', 'subawards': False}
-----
Requesting {'filters': {'time_period': [{'start_date': '2021-10-01', 'end_date': '2022-09-30'}], 'award_type_codes': ['02', '03', '04', '05'], 'place_of_performance_locations': [{'state': 'NY', 'county': '061', 'country': 'USA'}]}, 'fields': ['Award ID', 'Recipient Name', 'Award Amount', 'Awarding Agency', 'Awarding Sub Agency', 'Place of Performance State Code'], 'page': 29, 'limit': 100, 'sort': 'Award Amount', 'order': 'desc', 'subawards': False}
-----
Requesting {'filters': {'time_period': [{'start_date': '2021-10-01', 'end_date': '2022-09-30'}], 'award_type_codes': ['02', '03', '04', '05'], 'place_of_performance_locations': [{'state': 'NY', 'county': '061', 'country': 'USA'}]}, 'fields': ['Award ID', 'Recipient Name', 'Award Amount', 'Awarding Agency', 'Awarding Sub Agency', 'Place of Performance State Code'], 'page': 30, 'limit': 100, 'sort': 'Award Amount', 'order': 'desc', 'subawards': False}
-----
Requesting {'filters': {'time_period': [{'start_date': '2021-10-01', 'end_date': '2022-09-30'}], 'award_type_codes': ['02', '03', '04', '05'], 'place_of_performance_locations': [{'state': 'NY', 'county': '061', 'country': 'USA'}]}, 'fields': ['Award ID', 'Recipient Name', 'Award Amount', 'Awarding Agency', 'Awarding Sub Agency', 'Place of Performance State Code'], 'page': 31, 'limit': 100, 'sort': 'Award Amount', 'order': 'desc', 'subawards': False}
-----
Requesting {'filters': {'time_period': [{'start_date': '2021-10-01', 'end_date': '2022-09-30'}], 'award_type_codes': ['02', '03', '04', '05'], 'place_of_performance_locations': [{'state': 'NY', 'county': '061', 'country': 'USA'}]}, 'fields': ['Award ID', 'Recipient Name', 'Award Amount', 'Awarding Agency', 'Awarding Sub Agency', 'Place of Performance State Code'], 'page': 32, 'limit': 100, 'sort': 'Award Amount', 'order': 'desc', 'subawards': False}
-----
Requesting {'filters': {'time_period': [{'start_date': '2021-10-01', 'end_date': '2022-09-30'}], 'award_type_codes': ['02', '03', '04', '05'], 'place_of_performance_locations': [{'state': 'NY', 'county': '061', 'country': 'USA'}]}, 'fields': ['Award ID', 'Recipient Name', 'Award Amount', 'Awarding Agency', 'Awarding Sub Agency', 'Place of Performance State Code'], 'page': 33, 'limit': 100, 'sort': 'Award Amount', 'order': 'desc', 'subawards': False}
-----
Requesting {'filters': {'time_period': [{'start_date': '2021-10-01', 'end_date': '2022-09-30'}], 'award_type_codes': ['02', '03', '04', '05'], 'place_of_performance_locations': [{'state': 'NY', 'county': '061', 'country': 'USA'}]}, 'fields': ['Award ID', 'Recipient Name', 'Award Amount', 'Awarding Agency', 'Awarding Sub Agency', 'Place of Performance State Code'], 'page': 34, 'limit': 100, 'sort': 'Award Amount', 'order': 'desc', 'subawards': False}
-----
Requesting {'filters': {'time_period': [{'start_date': '2021-10-01', 'end_date': '2022-09-30'}], 'award_type_codes': ['02', '03', '04', '05'], 'place_of_performance_locations': [{'state': 'NY', 'county': '061', 'country': 'USA'}]}, 'fields': ['Award ID', 'Recipient Name', 'Award Amount', 'Awarding Agency', 'Awarding Sub Agency', 'Place of Performance State Code'], 'page': 35, 'limit': 100, 'sort': 'Award Amount', 'order': 'desc', 'subawards': False}
-----
Requesting {'filters': {'time_period': [{'start_date': '2021-10-01', 'end_date': '2022-09-30'}], 'award_type_codes': ['02', '03', '04', '05'], 'place_of_performance_locations': [{'state': 'NY', 'county': '061', 'country': 'USA'}]}, 'fields': ['Award ID', 'Recipient Name', 'Award Amount', 'Awarding Agency', 'Awarding Sub Agency', 'Place of Performance State Code'], 'page': 36, 'limit': 100, 'sort': 'Award Amount', 'order': 'desc', 'subawards': False}
-----
Requesting {'filters': {'time_period': [{'start_date': '2021-10-01', 'end_date': '2022-09-30'}], 'award_type_codes': ['02', '03', '04', '05'], 'place_of_performance_locations': [{'state': 'NY', 'county': '063', 'country': 'USA'}]}, 'fields': ['Award ID', 'Recipient Name', 'Award Amount', 'Awarding Agency', 'Awarding Sub Agency', 'Place of Performance State Code'], 'page': 1, 'limit': 100, 'sort': 'Award Amount', 'order': 'desc', 'subawards': False}
-----
Requesting {'filters': {'time_period': [{'start_date': '2021-10-01', 'end_date': '2022-09-30'}], 'award_type_codes': ['02', '03', '04', '05'], 'place_of_performance_locations': [{'state': 'NY', 'county': '065', 'country': 'USA'}]}, 'fields': ['Award ID', 'Recipient Name', 'Award Amount', 'Awarding Agency', 'Awarding Sub Agency', 'Place of Performance State Code'], 'page': 1, 'limit': 100, 'sort': 'Award Amount', 'order': 'desc', 'subawards': False}
-----
Requesting {'filters': {'time_period': [{'start_date': '2021-10-01', 'end_date': '2022-09-30'}], 'award_type_codes': ['02', '03', '04', '05'], 'place_of_performance_locations': [{'state': 'NY', 'county': '067', 'country': 'USA'}]}, 'fields': ['Award ID', 'Recipient Name', 'Award Amount', 'Awarding Agency', 'Awarding Sub Agency', 'Place of Performance State Code'], 'page': 1, 'limit': 100, 'sort': 'Award Amount', 'order': 'desc', 'subawards': False}
-----
Requesting {'filters': {'time_period': [{'start_date': '2021-10-01', 'end_date': '2022-09-30'}], 'award_type_codes': ['02', '03', '04', '05'], 'place_of_performance_locations': [{'state': 'NY', 'county': '067', 'country': 'USA'}]}, 'fields': ['Award ID', 'Recipient Name', 'Award Amount', 'Awarding Agency', 'Awarding Sub Agency', 'Place of Performance State Code'], 'page': 2, 'limit': 100, 'sort': 'Award Amount', 'order': 'desc', 'subawards': False}
-----
Requesting {'filters': {'time_period': [{'start_date': '2021-10-01', 'end_date': '2022-09-30'}], 'award_type_codes': ['02', '03', '04', '05'], 'place_of_performance_locations': [{'state': 'NY', 'county': '067', 'country': 'USA'}]}, 'fields': ['Award ID', 'Recipient Name', 'Award Amount', 'Awarding Agency', 'Awarding Sub Agency', 'Place of Performance State Code'], 'page': 3, 'limit': 100, 'sort': 'Award Amount', 'order': 'desc', 'subawards': False}
-----
Requesting {'filters': {'time_period': [{'start_date': '2021-10-01', 'end_date': '2022-09-30'}], 'award_type_codes': ['02', '03', '04', '05'], 'place_of_performance_locations': [{'state': 'NY', 'county': '069', 'country': 'USA'}]}, 'fields': ['Award ID', 'Recipient Name', 'Award Amount', 'Awarding Agency', 'Awarding Sub Agency', 'Place of Performance State Code'], 'page': 1, 'limit': 100, 'sort': 'Award Amount', 'order': 'desc', 'subawards': False}
-----
Requesting {'filters': {'time_period': [{'start_date': '2021-10-01', 'end_date': '2022-09-30'}], 'award_type_codes': ['02', '03', '04', '05'], 'place_of_performance_locations': [{'state': 'NY', 'county': '071', 'country': 'USA'}]}, 'fields': ['Award ID', 'Recipient Name', 'Award Amount', 'Awarding Agency', 'Awarding Sub Agency', 'Place of Performance State Code'], 'page': 1, 'limit': 100, 'sort': 'Award Amount', 'order': 'desc', 'subawards': False}
-----
Requesting {'filters': {'time_period': [{'start_date': '2021-10-01', 'end_date': '2022-09-30'}], 'award_type_codes': ['02', '03', '04', '05'], 'place_of_performance_locations': [{'state': 'NY', 'county': '073', 'country': 'USA'}]}, 'fields': ['Award ID', 'Recipient Name', 'Award Amount', 'Awarding Agency', 'Awarding Sub Agency', 'Place of Performance State Code'], 'page': 1, 'limit': 100, 'sort': 'Award Amount', 'order': 'desc', 'subawards': False}
-----
Requesting {'filters': {'time_period': [{'start_date': '2021-10-01', 'end_date': '2022-09-30'}], 'award_type_codes': ['02', '03', '04', '05'], 'place_of_performance_locations': [{'state': 'NY', 'county': '075', 'country': 'USA'}]}, 'fields': ['Award ID', 'Recipient Name', 'Award Amount', 'Awarding Agency', 'Awarding Sub Agency', 'Place of Performance State Code'], 'page': 1, 'limit': 100, 'sort': 'Award Amount', 'order': 'desc', 'subawards': False}
-----
Requesting {'filters': {'time_period': [{'start_date': '2021-10-01', 'end_date': '2022-09-30'}], 'award_type_codes': ['02', '03', '04', '05'], 'place_of_performance_locations': [{'state': 'NY', 'county': '077', 'country': 'USA'}]}, 'fields': ['Award ID', 'Recipient Name', 'Award Amount', 'Awarding Agency', 'Awarding Sub Agency', 'Place of Performance State Code'], 'page': 1, 'limit': 100, 'sort': 'Award Amount', 'order': 'desc', 'subawards': False}
-----
Requesting {'filters': {'time_period': [{'start_date': '2021-10-01', 'end_date': '2022-09-30'}], 'award_type_codes': ['02', '03', '04', '05'], 'place_of_performance_locations': [{'state': 'NY', 'county': '079', 'country': 'USA'}]}, 'fields': ['Award ID', 'Recipient Name', 'Award Amount', 'Awarding Agency', 'Awarding Sub Agency', 'Place of Performance State Code'], 'page': 1, 'limit': 100, 'sort': 'Award Amount', 'order': 'desc', 'subawards': False}
-----
Requesting {'filters': {'time_period': [{'start_date': '2021-10-01', 'end_date': '2022-09-30'}], 'award_type_codes': ['02', '03', '04', '05'], 'place_of_performance_locations': [{'state': 'NY', 'county': '081', 'country': 'USA'}]}, 'fields': ['Award ID', 'Recipient Name', 'Award Amount', 'Awarding Agency', 'Awarding Sub Agency', 'Place of Performance State Code'], 'page': 1, 'limit': 100, 'sort': 'Award Amount', 'order': 'desc', 'subawards': False}
-----
Requesting {'filters': {'time_period': [{'start_date': '2021-10-01', 'end_date': '2022-09-30'}], 'award_type_codes': ['02', '03', '04', '05'], 'place_of_performance_locations': [{'state': 'NY', 'county': '081', 'country': 'USA'}]}, 'fields': ['Award ID', 'Recipient Name', 'Award Amount', 'Awarding Agency', 'Awarding Sub Agency', 'Place of Performance State Code'], 'page': 2, 'limit': 100, 'sort': 'Award Amount', 'order': 'desc', 'subawards': False}
-----
Requesting {'filters': {'time_period': [{'start_date': '2021-10-01', 'end_date': '2022-09-30'}], 'award_type_codes': ['02', '03', '04', '05'], 'place_of_performance_locations': [{'state': 'NY', 'county': '083', 'country': 'USA'}]}, 'fields': ['Award ID', 'Recipient Name', 'Award Amount', 'Awarding Agency', 'Awarding Sub Agency', 'Place of Performance State Code'], 'page': 1, 'limit': 100, 'sort': 'Award Amount', 'order': 'desc', 'subawards': False}
-----
Requesting {'filters': {'time_period': [{'start_date': '2021-10-01', 'end_date': '2022-09-30'}], 'award_type_codes': ['02', '03', '04', '05'], 'place_of_performance_locations': [{'state': 'NY', 'county': '085', 'country': 'USA'}]}, 'fields': ['Award ID', 'Recipient Name', 'Award Amount', 'Awarding Agency', 'Awarding Sub Agency', 'Place of Performance State Code'], 'page': 1, 'limit': 100, 'sort': 'Award Amount', 'order': 'desc', 'subawards': False}
-----
Requesting {'filters': {'time_period': [{'start_date': '2021-10-01', 'end_date': '2022-09-30'}], 'award_type_codes': ['02', '03', '04', '05'], 'place_of_performance_locations': [{'state': 'NY', 'county': '087', 'country': 'USA'}]}, 'fields': ['Award ID', 'Recipient Name', 'Award Amount', 'Awarding Agency', 'Awarding Sub Agency', 'Place of Performance State Code'], 'page': 1, 'limit': 100, 'sort': 'Award Amount', 'order': 'desc', 'subawards': False}
-----
Requesting {'filters': {'time_period': [{'start_date': '2021-10-01', 'end_date': '2022-09-30'}], 'award_type_codes': ['02', '03', '04', '05'], 'place_of_performance_locations': [{'state': 'NY', 'county': '089', 'country': 'USA'}]}, 'fields': ['Award ID', 'Recipient Name', 'Award Amount', 'Awarding Agency', 'Awarding Sub Agency', 'Place of Performance State Code'], 'page': 1, 'limit': 100, 'sort': 'Award Amount', 'order': 'desc', 'subawards': False}
-----
Requesting {'filters': {'time_period': [{'start_date': '2021-10-01', 'end_date': '2022-09-30'}], 'award_type_codes': ['02', '03', '04', '05'], 'place_of_performance_locations': [{'state': 'NY', 'county': '091', 'country': 'USA'}]}, 'fields': ['Award ID', 'Recipient Name', 'Award Amount', 'Awarding Agency', 'Awarding Sub Agency', 'Place of Performance State Code'], 'page': 1, 'limit': 100, 'sort': 'Award Amount', 'order': 'desc', 'subawards': False}
-----
Requesting {'filters': {'time_period': [{'start_date': '2021-10-01', 'end_date': '2022-09-30'}], 'award_type_codes': ['02', '03', '04', '05'], 'place_of_performance_locations': [{'state': 'NY', 'county': '093', 'country': 'USA'}]}, 'fields': ['Award ID', 'Recipient Name', 'Award Amount', 'Awarding Agency', 'Awarding Sub Agency', 'Place of Performance State Code'], 'page': 1, 'limit': 100, 'sort': 'Award Amount', 'order': 'desc', 'subawards': False}
-----
Requesting {'filters': {'time_period': [{'start_date': '2021-10-01', 'end_date': '2022-09-30'}], 'award_type_codes': ['02', '03', '04', '05'], 'place_of_performance_locations': [{'state': 'NY', 'county': '095', 'country': 'USA'}]}, 'fields': ['Award ID', 'Recipient Name', 'Award Amount', 'Awarding Agency', 'Awarding Sub Agency', 'Place of Performance State Code'], 'page': 1, 'limit': 100, 'sort': 'Award Amount', 'order': 'desc', 'subawards': False}
-----
Requesting {'filters': {'time_period': [{'start_date': '2021-10-01', 'end_date': '2022-09-30'}], 'award_type_codes': ['02', '03', '04', '05'], 'place_of_performance_locations': [{'state': 'NY', 'county': '097', 'country': 'USA'}]}, 'fields': ['Award ID', 'Recipient Name', 'Award Amount', 'Awarding Agency', 'Awarding Sub Agency', 'Place of Performance State Code'], 'page': 1, 'limit': 100, 'sort': 'Award Amount', 'order': 'desc', 'subawards': False}
-----
Requesting {'filters': {'time_period': [{'start_date': '2021-10-01', 'end_date': '2022-09-30'}], 'award_type_codes': ['02', '03', '04', '05'], 'place_of_performance_locations': [{'state': 'NY', 'county': '099', 'country': 'USA'}]}, 'fields': ['Award ID', 'Recipient Name', 'Award Amount', 'Awarding Agency', 'Awarding Sub Agency', 'Place of Performance State Code'], 'page': 1, 'limit': 100, 'sort': 'Award Amount', 'order': 'desc', 'subawards': False}
-----
Requesting {'filters': {'time_period': [{'start_date': '2021-10-01', 'end_date': '2022-09-30'}], 'award_type_codes': ['02', '03', '04', '05'], 'place_of_performance_locations': [{'state': 'NY', 'county': '101', 'country': 'USA'}]}, 'fields': ['Award ID', 'Recipient Name', 'Award Amount', 'Awarding Agency', 'Awarding Sub Agency', 'Place of Performance State Code'], 'page': 1, 'limit': 100, 'sort': 'Award Amount', 'order': 'desc', 'subawards': False}
-----
Requesting {'filters': {'time_period': [{'start_date': '2021-10-01', 'end_date': '2022-09-30'}], 'award_type_codes': ['02', '03', '04', '05'], 'place_of_performance_locations': [{'state': 'NY', 'county': '103', 'country': 'USA'}]}, 'fields': ['Award ID', 'Recipient Name', 'Award Amount', 'Awarding Agency', 'Awarding Sub Agency', 'Place of Performance State Code'], 'page': 1, 'limit': 100, 'sort': 'Award Amount', 'order': 'desc', 'subawards': False}
-----
Requesting {'filters': {'time_period': [{'start_date': '2021-10-01', 'end_date': '2022-09-30'}], 'award_type_codes': ['02', '03', '04', '05'], 'place_of_performance_locations': [{'state': 'NY', 'county': '103', 'country': 'USA'}]}, 'fields': ['Award ID', 'Recipient Name', 'Award Amount', 'Awarding Agency', 'Awarding Sub Agency', 'Place of Performance State Code'], 'page': 2, 'limit': 100, 'sort': 'Award Amount', 'order': 'desc', 'subawards': False}
-----
Requesting {'filters': {'time_period': [{'start_date': '2021-10-01', 'end_date': '2022-09-30'}], 'award_type_codes': ['02', '03', '04', '05'], 'place_of_performance_locations': [{'state': 'NY', 'county': '103', 'country': 'USA'}]}, 'fields': ['Award ID', 'Recipient Name', 'Award Amount', 'Awarding Agency', 'Awarding Sub Agency', 'Place of Performance State Code'], 'page': 3, 'limit': 100, 'sort': 'Award Amount', 'order': 'desc', 'subawards': False}
-----
Requesting {'filters': {'time_period': [{'start_date': '2021-10-01', 'end_date': '2022-09-30'}], 'award_type_codes': ['02', '03', '04', '05'], 'place_of_performance_locations': [{'state': 'NY', 'county': '103', 'country': 'USA'}]}, 'fields': ['Award ID', 'Recipient Name', 'Award Amount', 'Awarding Agency', 'Awarding Sub Agency', 'Place of Performance State Code'], 'page': 4, 'limit': 100, 'sort': 'Award Amount', 'order': 'desc', 'subawards': False}
-----
Requesting {'filters': {'time_period': [{'start_date': '2021-10-01', 'end_date': '2022-09-30'}], 'award_type_codes': ['02', '03', '04', '05'], 'place_of_performance_locations': [{'state': 'NY', 'county': '105', 'country': 'USA'}]}, 'fields': ['Award ID', 'Recipient Name', 'Award Amount', 'Awarding Agency', 'Awarding Sub Agency', 'Place of Performance State Code'], 'page': 1, 'limit': 100, 'sort': 'Award Amount', 'order': 'desc', 'subawards': False}
-----
Requesting {'filters': {'time_period': [{'start_date': '2021-10-01', 'end_date': '2022-09-30'}], 'award_type_codes': ['02', '03', '04', '05'], 'place_of_performance_locations': [{'state': 'NY', 'county': '107', 'country': 'USA'}]}, 'fields': ['Award ID', 'Recipient Name', 'Award Amount', 'Awarding Agency', 'Awarding Sub Agency', 'Place of Performance State Code'], 'page': 1, 'limit': 100, 'sort': 'Award Amount', 'order': 'desc', 'subawards': False}
-----
Requesting {'filters': {'time_period': [{'start_date': '2021-10-01', 'end_date': '2022-09-30'}], 'award_type_codes': ['02', '03', '04', '05'], 'place_of_performance_locations': [{'state': 'NY', 'county': '109', 'country': 'USA'}]}, 'fields': ['Award ID', 'Recipient Name', 'Award Amount', 'Awarding Agency', 'Awarding Sub Agency', 'Place of Performance State Code'], 'page': 1, 'limit': 100, 'sort': 'Award Amount', 'order': 'desc', 'subawards': False}
-----
Requesting {'filters': {'time_period': [{'start_date': '2021-10-01', 'end_date': '2022-09-30'}], 'award_type_codes': ['02', '03', '04', '05'], 'place_of_performance_locations': [{'state': 'NY', 'county': '109', 'country': 'USA'}]}, 'fields': ['Award ID', 'Recipient Name', 'Award Amount', 'Awarding Agency', 'Awarding Sub Agency', 'Place of Performance State Code'], 'page': 2, 'limit': 100, 'sort': 'Award Amount', 'order': 'desc', 'subawards': False}
-----
Requesting {'filters': {'time_period': [{'start_date': '2021-10-01', 'end_date': '2022-09-30'}], 'award_type_codes': ['02', '03', '04', '05'], 'place_of_performance_locations': [{'state': 'NY', 'county': '109', 'country': 'USA'}]}, 'fields': ['Award ID', 'Recipient Name', 'Award Amount', 'Awarding Agency', 'Awarding Sub Agency', 'Place of Performance State Code'], 'page': 3, 'limit': 100, 'sort': 'Award Amount', 'order': 'desc', 'subawards': False}
-----
Requesting {'filters': {'time_period': [{'start_date': '2021-10-01', 'end_date': '2022-09-30'}], 'award_type_codes': ['02', '03', '04', '05'], 'place_of_performance_locations': [{'state': 'NY', 'county': '109', 'country': 'USA'}]}, 'fields': ['Award ID', 'Recipient Name', 'Award Amount', 'Awarding Agency', 'Awarding Sub Agency', 'Place of Performance State Code'], 'page': 4, 'limit': 100, 'sort': 'Award Amount', 'order': 'desc', 'subawards': False}
-----
Requesting {'filters': {'time_period': [{'start_date': '2021-10-01', 'end_date': '2022-09-30'}], 'award_type_codes': ['02', '03', '04', '05'], 'place_of_performance_locations': [{'state': 'NY', 'county': '111', 'country': 'USA'}]}, 'fields': ['Award ID', 'Recipient Name', 'Award Amount', 'Awarding Agency', 'Awarding Sub Agency', 'Place of Performance State Code'], 'page': 1, 'limit': 100, 'sort': 'Award Amount', 'order': 'desc', 'subawards': False}
-----
Requesting {'filters': {'time_period': [{'start_date': '2021-10-01', 'end_date': '2022-09-30'}], 'award_type_codes': ['02', '03', '04', '05'], 'place_of_performance_locations': [{'state': 'NY', 'county': '113', 'country': 'USA'}]}, 'fields': ['Award ID', 'Recipient Name', 'Award Amount', 'Awarding Agency', 'Awarding Sub Agency', 'Place of Performance State Code'], 'page': 1, 'limit': 100, 'sort': 'Award Amount', 'order': 'desc', 'subawards': False}
-----
Requesting {'filters': {'time_period': [{'start_date': '2021-10-01', 'end_date': '2022-09-30'}], 'award_type_codes': ['02', '03', '04', '05'], 'place_of_performance_locations': [{'state': 'NY', 'county': '115', 'country': 'USA'}]}, 'fields': ['Award ID', 'Recipient Name', 'Award Amount', 'Awarding Agency', 'Awarding Sub Agency', 'Place of Performance State Code'], 'page': 1, 'limit': 100, 'sort': 'Award Amount', 'order': 'desc', 'subawards': False}
-----
Requesting {'filters': {'time_period': [{'start_date': '2021-10-01', 'end_date': '2022-09-30'}], 'award_type_codes': ['02', '03', '04', '05'], 'place_of_performance_locations': [{'state': 'NY', 'county': '117', 'country': 'USA'}]}, 'fields': ['Award ID', 'Recipient Name', 'Award Amount', 'Awarding Agency', 'Awarding Sub Agency', 'Place of Performance State Code'], 'page': 1, 'limit': 100, 'sort': 'Award Amount', 'order': 'desc', 'subawards': False}
-----
Requesting {'filters': {'time_period': [{'start_date': '2021-10-01', 'end_date': '2022-09-30'}], 'award_type_codes': ['02', '03', '04', '05'], 'place_of_performance_locations': [{'state': 'NY', 'county': '119', 'country': 'USA'}]}, 'fields': ['Award ID', 'Recipient Name', 'Award Amount', 'Awarding Agency', 'Awarding Sub Agency', 'Place of Performance State Code'], 'page': 1, 'limit': 100, 'sort': 'Award Amount', 'order': 'desc', 'subawards': False}
-----
Requesting {'filters': {'time_period': [{'start_date': '2021-10-01', 'end_date': '2022-09-30'}], 'award_type_codes': ['02', '03', '04', '05'], 'place_of_performance_locations': [{'state': 'NY', 'county': '119', 'country': 'USA'}]}, 'fields': ['Award ID', 'Recipient Name', 'Award Amount', 'Awarding Agency', 'Awarding Sub Agency', 'Place of Performance State Code'], 'page': 2, 'limit': 100, 'sort': 'Award Amount', 'order': 'desc', 'subawards': False}
-----
Requesting {'filters': {'time_period': [{'start_date': '2021-10-01', 'end_date': '2022-09-30'}], 'award_type_codes': ['02', '03', '04', '05'], 'place_of_performance_locations': [{'state': 'NY', 'county': '119', 'country': 'USA'}]}, 'fields': ['Award ID', 'Recipient Name', 'Award Amount', 'Awarding Agency', 'Awarding Sub Agency', 'Place of Performance State Code'], 'page': 3, 'limit': 100, 'sort': 'Award Amount', 'order': 'desc', 'subawards': False}
-----
Requesting {'filters': {'time_period': [{'start_date': '2021-10-01', 'end_date': '2022-09-30'}], 'award_type_codes': ['02', '03', '04', '05'], 'place_of_performance_locations': [{'state': 'NY', 'county': '121', 'country': 'USA'}]}, 'fields': ['Award ID', 'Recipient Name', 'Award Amount', 'Awarding Agency', 'Awarding Sub Agency', 'Place of Performance State Code'], 'page': 1, 'limit': 100, 'sort': 'Award Amount', 'order': 'desc', 'subawards': False}
-----
Requesting {'filters': {'time_period': [{'start_date': '2021-10-01', 'end_date': '2022-09-30'}], 'award_type_codes': ['02', '03', '04', '05'], 'place_of_performance_locations': [{'state': 'NY', 'county': '123', 'country': 'USA'}]}, 'fields': ['Award ID', 'Recipient Name', 'Award Amount', 'Awarding Agency', 'Awarding Sub Agency', 'Place of Performance State Code'], 'page': 1, 'limit': 100, 'sort': 'Award Amount', 'order': 'desc', 'subawards': False}

# check the total transactions 
len(all_county)

8772

# clean the request results 
data_response_0 = [[d["Award ID"],d["Recipient Name"],d["Award Amount"],d["Awarding Agency"],d["Awarding Sub Agency"],d["Place of Performance State Code"],d["county_code"]] for d in all_county]
county_grants = pd.DataFrame(data_response_0,columns = ["Award_ID","Recipient_Name","Award_Amount","Awarding_Agency","Awarding_Sub_Agency","Place_of_Performance_State_Code","county_code"])
#county_grants

#calculate the sum of each county
county_grants_each_sep = county_grants.filter(["Award_Amount","county_code"])
county_grants_each_sum = county_grants_each_sep.groupby(["county_code"]).sum()
county_grants_each_sum.reset_index(drop=False, inplace=True)
#county_grants_each_sum

Merge Population_County_Code with County Grants Data

population_grants = population_county_code.merge(county_grants_each_sum, how = "left", left_on='county_code', right_on='county_code')
# calculate grants_per_capita
population_grants["grants_per_capita"] = population_grants["Award_Amount"]/population_grants["Population2019"]

county_grants_NY = population_grants
#county_grants_NY

len(county_grants_NY)

62

#county_grants_NY.loc[29,"County"] = "La Salle Parish"
#county_grants_NY = county_grants_NY.drop(119)
#county_grants_NY =  county_grants_NY.fillna(0)
#county_grants_NY

#county_grants_NY['County'] = county_grants_NY['County'] .apply(lambda x: x.split(' Parish')[0])
#county_grants_NY

#export data
#county_grants_NY.to_csv('C:/Users/little page/Desktop/final_USAspending/grants_data/county_grants_WI.csv')

Data Vis for USAspending Explorer App

The First Result

#county_grants_NY = pd.read_csv("county_grants_PA.csv")

#county_grants_NY

# data wrangling 
county_grants_NY_vis = county_grants_NY.filter(["County","Award_Amount","grants_per_capita"])
county_grants_NY_vis = county_grants_NY_vis.rename(columns={"County":"County Name","Award_Amount":"Total Federal Grant Funding Amount",
                                                            "grants_per_capita":"Total Per Capita Federal Grant Funding"})


county_grants_NY_vis=county_grants_NY_vis.sort_values(by='Total Per Capita Federal Grant Funding',ascending=False,axis=0)


#county_grants_NY_vis

# add "$" mark
County_Name_list = []
for ii in county_grants_NY_vis["County Name"]:
    County_Name_list.append(ii)
    
total_list = []
for ii in county_grants_NY_vis["Total Federal Grant Funding Amount"]:
    currency_form = "${:,.2f}".format(ii)
    total_list.append(currency_form )
    
per_list = []
for ii in county_grants_NY_vis["Total Per Capita Federal Grant Funding"]:
    currency_form_2 = "${:,.2f}".format(ii)
    per_list.append(currency_form_2)

cc={"total_list":total_list,"per_list":per_list,"County_Name_list":County_Name_list}
NY_county_grants_vis = DataFrame(cc)

NY_county_grants_vis = NY_county_grants_vis.rename(columns={"County_Name_list":"County Name",
                                                            "total_list":"Total Federal Grant Funding Amount",
                                                            "per_list":"Total Per Capita Federal Grant Funding"})
NY_county_grants_vis = NY_county_grants_vis.filter(["County Name","Total Federal Grant Funding Amount",
                                                    "Total Per Capita Federal Grant Funding"])

NY_county_grants_vis

	County Name	Total Federal Grant Funding Amount	Total Per Capita Federal Grant Funding
0	Albany	$25,025,610,741.95	$81,915.28
1	New York	$10,577,126,126.44	$6,494.19
2	Tompkins	$390,389,889.90	$3,820.61
3	Cayuga	$235,172,479.32	$3,071.10
4	Chenango	$135,723,001.49	$2,875.06
5	Monroe	$1,017,116,807.90	$1,371.20
6	Franklin	$61,287,128.18	$1,225.20
7	Cattaraugus	$83,397,439.24	$1,095.65
8	Yates	$27,239,595.08	$1,093.39
9	Schenectady	$149,641,349.44	$963.57
10	Rensselaer	$144,945,233.79	$913.25
11	Allegany	$41,583,081.82	$902.20
12	Bronx	$1,163,075,896.14	$820.10
13	Westchester	$754,851,151.45	$780.20
14	Erie	$705,844,859.36	$768.31
15	Lewis	$20,068,190.00	$763.17
16	Delaware	$33,335,624.74	$755.31
17	Suffolk	$1,058,461,159.63	$716.82
18	Schoharie	$20,281,075.00	$654.25
19	Warren	$41,405,073.65	$647.52
20	Columbia	$37,311,436.19	$627.49
21	Onondaga	$288,849,896.15	$627.21
22	Jefferson	$68,675,999.49	$625.27
23	Otsego	$37,099,256.00	$623.59
24	Queens	$1,284,369,840.65	$569.85
25	Cortland	$26,295,966.08	$552.66
26	Rockland	$179,880,796.29	$552.14
27	Chautauqua	$65,974,373.26	$519.88
28	Schuyler	$9,172,829.38	$515.12
29	Clinton	$40,633,105.80	$504.85
30	Steuben	$47,122,937.69	$494.06
31	Oneida	$102,447,812.49	$448.01
32	Orleans	$17,904,757.94	$443.71
33	Broome	$80,310,065.92	$421.60
34	St. Lawrence	$44,654,992.85	$414.47
35	Chemung	$32,513,076.11	$389.58
36	Putnam	$38,142,304.00	$387.94
37	Hamilton	$1,677,964.00	$379.97
38	Ulster	$66,606,622.61	$375.09
39	Montgomery	$17,233,007.00	$350.11
40	Washington	$21,112,577.00	$344.95
41	Kings	$851,093,630.18	$332.47
42	Dutchess	$97,454,830.21	$331.23
43	Oswego	$36,086,750.63	$308.11
44	Sullivan	$21,919,617.28	$290.59
45	Essex	$10,197,533.38	$276.47
46	Wayne	$23,436,233.00	$260.64
47	Wyoming	$9,804,536.00	$245.98
48	Seneca	$8,332,936.00	$244.97
49	Orange	$93,297,735.03	$242.37
50	Fulton	$11,865,227.00	$222.27
51	Greene	$7,924,714.81	$167.94
52	Niagara	$34,701,208.69	$165.81
53	Genesee	$8,906,252.87	$155.49
54	Madison	$10,572,189.23	$149.03
55	Nassau	$198,795,957.67	$146.50
56	Tioga	$6,852,960.58	$142.17
57	Ontario	$14,660,439.57	$133.55
58	Saratoga	$29,166,655.16	$126.89
59	Richmond	$57,933,091.49	$121.67
60	Herkimer	$5,455,057.00	$88.96
61	Livingston	$4,021,269.00	$63.92

The Second Result

## Read in geojson
NY_county = json.load(open("mergedfile_new_york_36.geojson","r"))
#NY_county["features"]

## edit the data/info in the geojson file when necessary
#Valley_dictionary = { "type": "Feature", "properties": { "kind": "county", "name": "Valley", "state": "MT" }, "geometry": { "type": "MultiPolygon", "coordinates":   [[[[-106.0192,48.5621],[-106.0192,48.8250],[-106.1507,48.8250],[-106.1123,49.0002], [-105.8440, 48.0089], [-105.8440, 48.2170], [-105.8056, 48.2170], [-105.8056, 48.5621], [-105.8440, 48.0089],[-105.8933, 48.0363],[-105.9097, 48.0034],[-106.0138, 48.0363],[-106.0302, 48.0034],[-106.0850, 48.0363],[-106.1178, 48.0034],[-106.1452, 48.0089],[-106.1288, 48.0308],[-106.3917, 48.0637], [-106.4300, 48.0199], [-106.4190, 47.9596], [-106.4190, 47.9596],[-106.4410, 47.9815],[106.4902, 47.9596],[-106.4957, 47.9158],[-106.5286, 47.9049],[-106.5067, 47.8829],[-106.5395, 47.8775],[-106.5286, 47.8501],[-106.6107, 47.8063],[-106.6107, 47.7789],[-106.7093, 47.7734],[-106.7531, 47.7296],[-106.8627, 47.7351],[-106.8901, 47.6748],[-107.2461, 47.6639],[-107.4159, 47.6913],[-107.1803, 48.9126], [-107.2077, 48.9126], [-107.1913, 48.5073],  [-107.2515, 48.5183], [-107.2570, 48.4799],  [-107.3008, 48.4799],  [-107.2625, 48.3047],  [-107.3720, 48.3047],  [-107.3720, 48.2170], [-107.4049, 48.2170], [-107.4159, 47.6913], [-107.1803, 49.0002]]]]}}
#NY_county["features"].append(Valley_dictionary)

# store the edited geojson file 
#with open('C:/Users/little page/Desktop/final_USAspending/geojson_data/mergedfile_MT.geojson', 'w', encoding='utf-8') as f:
    #json.dump(NY_county, f, ensure_ascii=False)

# prepare for plotting
state_id_map = {}
for feature in NY_county["features"]:
    feature["id"] = feature["properties"]['name']
    state_id_map[feature["properties"]['name']] = feature["id"]
    
county_grants_NY["id"] = county_grants_NY["County"].apply(lambda x:state_id_map[x])

county_grants_NY["grants_per_capita"]=round(county_grants_NY["grants_per_capita"],3)
#county_grants_NY

# set the value "< 0" = 1
county_grants_NY["grants_per_capita"][county_grants_NY.grants_per_capita< 0]=1

<ipython-input-37-84afc3f7b293>:2: SettingWithCopyWarning: 
A value is trying to be set on a copy of a slice from a DataFrame

See the caveats in the documentation: https://pandas.pydata.org/pandas-docs/stable/user_guide/indexing.html#returning-a-view-versus-a-copy
  county_grants_NY["grants_per_capita"][county_grants_NY.grants_per_capita< 0]=1

#county_grants_NY

# log the numbers
county_grants_NY["grants_per_capita_scale"] = np.log10(county_grants_NY["grants_per_capita"])

county_grants_NY = county_grants_NY.merge(NY_county_grants_vis, how = "left", left_on='County', right_on='County Name')
county_grants_NY = county_grants_NY.rename(columns={"grants_per_capita_scale":"Per Capita Scale"})
county_grants_NY

	State_x	Code	County	county_code	Population2019	Award_Amount	grants_per_capita	id	Per Capita Scale	County Name	Total Federal Grant Funding Amount	Total Per Capita Federal Grant Funding
0	New York	NY	Albany	001	305506	2.502561e+10	81915.284	Albany	4.913365	Albany	$25,025,610,741.95	$81,915.28
1	New York	NY	Allegany	003	46091	4.158308e+07	902.195	Allegany	2.955300	Allegany	$41,583,081.82	$902.20
2	New York	NY	Bronx	005	1418207	1.163076e+09	820.103	Bronx	2.913868	Bronx	$1,163,075,896.14	$820.10
3	New York	NY	Broome	007	190488	8.031007e+07	421.602	Broome	2.624903	Broome	$80,310,065.92	$421.60
4	New York	NY	Cattaraugus	009	76117	8.339744e+07	1095.648	Cattaraugus	3.039671	Cattaraugus	$83,397,439.24	$1,095.65
5	New York	NY	Cayuga	011	76576	2.351725e+08	3071.099	Cayuga	3.487294	Cayuga	$235,172,479.32	$3,071.10
6	New York	NY	Chautauqua	013	126903	6.597437e+07	519.880	Chautauqua	2.715903	Chautauqua	$65,974,373.26	$519.88
7	New York	NY	Chemung	015	83456	3.251308e+07	389.583	Chemung	2.590600	Chemung	$32,513,076.11	$389.58
8	New York	NY	Chenango	017	47207	1.357230e+08	2875.061	Chenango	3.458647	Chenango	$135,723,001.49	$2,875.06
9	New York	NY	Clinton	019	80485	4.063311e+07	504.853	Clinton	2.703165	Clinton	$40,633,105.80	$504.85
10	New York	NY	Columbia	021	59461	3.731144e+07	627.494	Columbia	2.797610	Columbia	$37,311,436.19	$627.49
11	New York	NY	Cortland	023	47581	2.629597e+07	552.657	Cortland	2.742456	Cortland	$26,295,966.08	$552.66
12	New York	NY	Delaware	025	44135	3.333562e+07	755.310	Delaware	2.878125	Delaware	$33,335,624.74	$755.31
13	New York	NY	Dutchess	027	294218	9.745483e+07	331.233	Dutchess	2.520134	Dutchess	$97,454,830.21	$331.23
14	New York	NY	Erie	029	918702	7.058449e+08	768.307	Erie	2.885535	Erie	$705,844,859.36	$768.31
15	New York	NY	Essex	031	36885	1.019753e+07	276.468	Essex	2.441645	Essex	$10,197,533.38	$276.47
16	New York	NY	Franklin	033	50022	6.128713e+07	1225.203	Franklin	3.088208	Franklin	$61,287,128.18	$1,225.20
17	New York	NY	Fulton	035	53383	1.186523e+07	222.266	Fulton	2.346873	Fulton	$11,865,227.00	$222.27
18	New York	NY	Genesee	037	57280	8.906253e+06	155.486	Genesee	2.191691	Genesee	$8,906,252.87	$155.49
19	New York	NY	Greene	039	47188	7.924715e+06	167.939	Greene	2.225152	Greene	$7,924,714.81	$167.94
20	New York	NY	Hamilton	041	4416	1.677964e+06	379.974	Hamilton	2.579754	Hamilton	$1,677,964.00	$379.97
21	New York	NY	Herkimer	043	61319	5.455057e+06	88.962	Herkimer	1.949205	Herkimer	$5,455,057.00	$88.96
22	New York	NY	Jefferson	045	109834	6.867600e+07	625.271	Jefferson	2.796068	Jefferson	$68,675,999.49	$625.27
23	New York	NY	Kings	047	2559903	8.510936e+08	332.471	Kings	2.521754	Kings	$851,093,630.18	$332.47
24	New York	NY	Lewis	049	26296	2.006819e+07	763.165	Lewis	2.882618	Lewis	$20,068,190.00	$763.17
25	New York	NY	Livingston	051	62914	4.021269e+06	63.917	Livingston	1.805616	Livingston	$4,021,269.00	$63.92
26	New York	NY	Madison	053	70941	1.057219e+07	149.028	Madison	2.173268	Madison	$10,572,189.23	$149.03
27	New York	NY	Monroe	055	741770	1.017117e+09	1371.202	Monroe	3.137101	Monroe	$1,017,116,807.90	$1,371.20
28	New York	NY	Montgomery	057	49221	1.723301e+07	350.115	Montgomery	2.544211	Montgomery	$17,233,007.00	$350.11
29	New York	NY	Nassau	059	1356924	1.987960e+08	146.505	Nassau	2.165852	Nassau	$198,795,957.67	$146.50
30	New York	NY	New York	061	1628706	1.057713e+10	6494.190	New York	3.812525	New York	$10,577,126,126.44	$6,494.19
31	New York	NY	Niagara	063	209281	3.470121e+07	165.812	Niagara	2.219616	Niagara	$34,701,208.69	$165.81
32	New York	NY	Oneida	065	228671	1.024478e+08	448.014	Oneida	2.651292	Oneida	$102,447,812.49	$448.01
33	New York	NY	Onondaga	067	460528	2.888499e+08	627.215	Onondaga	2.797416	Onondaga	$288,849,896.15	$627.21
34	New York	NY	Ontario	069	109777	1.466044e+07	133.547	Ontario	2.125634	Ontario	$14,660,439.57	$133.55
35	New York	NY	Orange	071	384940	9.329774e+07	242.370	Orange	2.384479	Orange	$93,297,735.03	$242.37
36	New York	NY	Orleans	073	40352	1.790476e+07	443.714	Orleans	2.647103	Orleans	$17,904,757.94	$443.71
37	New York	NY	Oswego	075	117124	3.608675e+07	308.107	Oswego	2.488702	Oswego	$36,086,750.63	$308.11
38	New York	NY	Otsego	077	59493	3.709926e+07	623.590	Otsego	2.794899	Otsego	$37,099,256.00	$623.59
39	New York	NY	Putnam	079	98320	3.814230e+07	387.940	Putnam	2.588765	Putnam	$38,142,304.00	$387.94
40	New York	NY	Queens	081	2253858	1.284370e+09	569.854	Queens	2.755764	Queens	$1,284,369,840.65	$569.85
41	New York	NY	Rensselaer	083	158714	1.449452e+08	913.248	Rensselaer	2.960589	Rensselaer	$144,945,233.79	$913.25
42	New York	NY	Richmond	085	476143	5.793309e+07	121.672	Richmond	2.085191	Richmond	$57,933,091.49	$121.67
43	New York	NY	Rockland	087	325789	1.798808e+08	552.139	Rockland	2.742048	Rockland	$179,880,796.29	$552.14
44	New York	NY	St. Lawrence	089	107740	4.465499e+07	414.470	St. Lawrence	2.617493	St. Lawrence	$44,654,992.85	$414.47
45	New York	NY	Saratoga	091	229863	2.916666e+07	126.887	Saratoga	2.103417	Saratoga	$29,166,655.16	$126.89
46	New York	NY	Schenectady	093	155299	1.496413e+08	963.569	Schenectady	2.983883	Schenectady	$149,641,349.44	$963.57
47	New York	NY	Schoharie	095	30999	2.028108e+07	654.249	Schoharie	2.815743	Schoharie	$20,281,075.00	$654.25
48	New York	NY	Schuyler	097	17807	9.172829e+06	515.125	Schuyler	2.711913	Schuyler	$9,172,829.38	$515.12
49	New York	NY	Seneca	099	34016	8.332936e+06	244.971	Seneca	2.389115	Seneca	$8,332,936.00	$244.97
50	New York	NY	Steuben	101	95379	4.712294e+07	494.060	Steuben	2.693780	Steuben	$47,122,937.69	$494.06
51	New York	NY	Suffolk	103	1476601	1.058461e+09	716.823	Suffolk	2.855412	Suffolk	$1,058,461,159.63	$716.82
52	New York	NY	Sullivan	105	75432	2.191962e+07	290.588	Sullivan	2.463278	Sullivan	$21,919,617.28	$290.59
53	New York	NY	Tioga	107	48203	6.852961e+06	142.169	Tioga	2.152805	Tioga	$6,852,960.58	$142.17
54	New York	NY	Tompkins	109	102180	3.903899e+08	3820.610	Tompkins	3.582133	Tompkins	$390,389,889.90	$3,820.61
55	New York	NY	Ulster	111	177573	6.660662e+07	375.094	Ulster	2.574140	Ulster	$66,606,622.61	$375.09
56	New York	NY	Warren	113	63944	4.140507e+07	647.521	Warren	2.811254	Warren	$41,405,073.65	$647.52
57	New York	NY	Washington	115	61204	2.111258e+07	344.954	Washington	2.537761	Washington	$21,112,577.00	$344.95
58	New York	NY	Wayne	117	89918	2.343623e+07	260.640	Wayne	2.416041	Wayne	$23,436,233.00	$260.64
59	New York	NY	Westchester	119	967506	7.548512e+08	780.203	Westchester	2.892208	Westchester	$754,851,151.45	$780.20
60	New York	NY	Wyoming	121	39859	9.804536e+06	245.980	Wyoming	2.390900	Wyoming	$9,804,536.00	$245.98
61	New York	NY	Yates	123	24913	2.723960e+07	1093.389	Yates	3.038775	Yates	$27,239,595.08	$1,093.39

# plot 
fig = px.choropleth_mapbox(county_grants_NY,
                    locations = "id",
                    geojson = NY_county,
                    color="Per Capita Scale",
                   hover_name = "County Name",
                   hover_data = ["Total Per Capita Federal Grant Funding"],
                     mapbox_style = "carto-positron",
                     center = {"lat": 43.000000,"lon":-75.000000},
                     zoom= 5.3,opacity = 0.3
                    )
fig.show()

The Third Result

FIPS_code_state = pd.read_csv("FIPS_code_state.csv")
FIPS_code_state["FIPS"] = FIPS_code_state["FIPS"].apply(lambda x:str(x).zfill(2))
#FIPS_code_state

# use New York as an example
FIPS_code = "36"

Request the USAspending API

• Documentation:
  • USAspending https://www.usaspending.gov/
  • Endpoint: https://api.usaspending.gov/api/v2/recipient/state/

# form the request url(2012-2022) 
year_list = [2012,2013,2014,2015,2016,2017,2018,2019,2020,2021,2022]
year_list_1 = [ str(x) for x in year_list]

one_state = []

for year in year_list_1:
    url = "https://api.usaspending.gov/api/v2/recipient/state/" + FIPS_code + "/" + "?year=" + year
    one_state.append(url)

# store the data/info from the request
info_one_state = []
for ii in one_state:
    r = requests.get(ii)
    print(ii)
    r0_1=r.json()
    info_one_state.append(r0_1)   

https://api.usaspending.gov/api/v2/recipient/state/36/?year=2012
https://api.usaspending.gov/api/v2/recipient/state/36/?year=2013
https://api.usaspending.gov/api/v2/recipient/state/36/?year=2014
https://api.usaspending.gov/api/v2/recipient/state/36/?year=2015
https://api.usaspending.gov/api/v2/recipient/state/36/?year=2016
https://api.usaspending.gov/api/v2/recipient/state/36/?year=2017
https://api.usaspending.gov/api/v2/recipient/state/36/?year=2018
https://api.usaspending.gov/api/v2/recipient/state/36/?year=2019
https://api.usaspending.gov/api/v2/recipient/state/36/?year=2020
https://api.usaspending.gov/api/v2/recipient/state/36/?year=2021
https://api.usaspending.gov/api/v2/recipient/state/36/?year=2022

# put the results into a df
info_one_state = pd.DataFrame(info_one_state)
info_one_state0 = info_one_state.filter(["code","fips","total_prime_amount",'population'])
info_one_state0["award_per_capita"]  = round(info_one_state0["total_prime_amount"]/info_one_state0["population"],2)
info_one_state0["year"] = year_list
info_one_state0

	code	fips	total_prime_amount	population	award_per_capita	year
0	NY	36	1.532928e+11	19625409	7810.94	2012
1	NY	36	1.652047e+11	19712514	8380.70	2013
2	NY	36	1.300704e+11	19773580	6577.99	2014
3	NY	36	1.474368e+11	19819347	7439.04	2015
4	NY	36	1.541537e+11	19836286	7771.30	2016
5	NY	36	1.739867e+11	19849399	8765.34	2017
6	NY	36	1.745209e+11	19849399	8792.25	2018
7	NY	36	1.824635e+11	19849399	9192.39	2019
8	NY	36	2.634591e+11	19849399	13272.90	2020
9	NY	36	2.940153e+11	19849399	14812.30	2021
10	NY	36	1.525954e+11	19849399	7687.66	2022

## plot
#create figure with secondary y-axis
fig = make_subplots(specs=[[{"secondary_y": True}]])

## add traces
fig.add_trace(
    go.Scatter(
        x=[2012, 2013, 2014, 2015, 2016, 2017, 2018,2019, 2020, 2021, 2022],
        y=info_one_state0['award_per_capita'],
        name="award_amount_per_capita",
        mode='lines+markers', 
        marker=dict(size=9,
                symbol = 'diamond',
                color ='RGB(251, 177, 36)',
                line_width = 2),
        line = dict(color='firebrick', width=3)),
        secondary_y=True
    )

fig.add_trace(
    go.Bar(
        x=[2012, 2013, 2014, 2015, 2016, 2017, 2018,2019, 2020, 2021, 2022],
        y=info_one_state0['total_prime_amount'],
        name="total_prime_amount",
        text = info_one_state0['total_prime_amount'],
        textposition='outside',
        textfont=dict(
        size=13,
        color='#1f77b4'),
        marker_color=["#f3e5f5", '#e1bee7', '#ce93d8', '#ba68c8','#ab47bc',
                     '#9c27b0','#8e24aa','#7b1fa2','#6a1b9a','#4a148c','#3c0a99'], 
        marker_line_color='rgb(17, 69, 126)',
        marker_line_width=1, 
        opacity=0.7),
        secondary_y=False
    )

# strip down the rest of the plot
fig.update_traces(texttemplate='%{text:.2s}')

fig.update_layout(
    showlegend=True,
    plot_bgcolor="rgb(240,240,240)",
    margin=dict(t=50,l=10,b=10,r=10),
    title_text='2012-2022 Prime Amount',
    title_font_family='Times New Roman',
    legend_title_text='Dollars Obligated',
    title_font_size = 25,
    title_font_color="darkblue",
    title_x=0.5,
    xaxis=dict(
    tickfont_size=14,
    tickangle = 270,
    showgrid = True,
    zeroline = True,
    showline = True,
    showticklabels = True,
    dtick=1
    ),
    legend=dict(
    x=0.01,
    y=0.99,
    bgcolor='rgba(255, 255, 255, 0)',
    bordercolor='rgba(255, 255, 255, 0)'
    ),
    bargap=0.15
)

## set y-axes titles
fig.update_yaxes(title_text='Total Prime Amount  USD', 
                 titlefont_size=16, 
                 tickfont_size=14,
                 secondary_y=False)
fig.update_yaxes(title_text='Award Amount Per Capita  USD', 
                 titlefont_size=16, 
                 tickfont_size=14, 
                 secondary_y=True)
    

fig.show()

The End